Car Dataset Report

Brought to you by YData

Dataset statistics

Number of variables	15
Number of observations	50000
Missing cells	11299
Missing cells (%)	1.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.7 MiB
Average record size in memory	120.0 B

Variable types

Numeric	4
Text	7
Categorical	4

Alerts

`color` is highly overall correlated with `transmission`	High correlation
`odometer` is highly overall correlated with `sellingprice` and 1 other fields	High correlation
`sellingprice` is highly overall correlated with `odometer` and 1 other fields	High correlation
`state` is highly overall correlated with `transmission`	High correlation
`transmission` is highly overall correlated with `color` and 1 other fields	High correlation
`year` is highly overall correlated with `odometer` and 1 other fields	High correlation
`transmission` is highly imbalanced (86.4%)	Imbalance
`interior` is highly imbalanced (50.6%)	Imbalance
`make` has 953 (1.9%) missing values	Missing
`model` has 963 (1.9%) missing values	Missing
`trim` has 988 (2.0%) missing values	Missing
`body` has 1218 (2.4%) missing values	Missing
`transmission` has 5986 (12.0%) missing values	Missing
`condition` has 1077 (2.2%) missing values	Missing

Reproduction

Analysis started	2025-06-05 20:52:59.781594
Analysis finished	2025-06-05 20:53:04.967085
Duration	5.19 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

year
Real number (ℝ)

High correlation

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2010.044

Minimum	1986
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	390.8 KiB

Quantile statistics

Minimum	1986
5-th percentile	2002
Q1	2007
median	2012
Q3	2013
95-th percentile	2014
Maximum	2015
Range	29
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.9535929
Coefficient of variation (CV)	0.0019669186
Kurtosis	0.95061593
Mean	2010.044
Median Absolute Deviation (MAD)	2
Skewness	-1.1784015
Sum	1.005022 × 10⁸
Variance	15.630897
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
2012	9253	18.5%
2013	8815	17.6%
2014	7243	14.5%
2011	4282	8.6%
2008	2794	5.6%
2007	2765	5.5%
2006	2483	5.0%
2010	2349	4.7%
2005	1925	3.9%
2009	1883	3.8%
Other values (17)	6208	12.4%

Value	Count	Frequency (%)
1986	1	< 0.1%
1990	3	< 0.1%
1991	5	< 0.1%
1992	10	< 0.1%
1993	19	< 0.1%
1994	43	0.1%
1995	66	0.1%
1996	84	0.2%
1997	140	0.3%
1998	167	0.3%

Value	Count	Frequency (%)
2015	793	1.6%
2014	7243	14.5%
2013	8815	17.6%
2012	9253	18.5%
2011	4282	8.6%
2010	2349	4.7%
2009	1883	3.8%
2008	2794	5.6%
2007	2765	5.5%
2006	2483	5.0%

make
Text

Missing

Distinct	80
Distinct (%)	0.2%
Missing	953
Missing (%)	1.9%
Memory size	390.8 KiB

Length

Max length	13
Median length	11
Mean length	6.0031195
Min length	2

Characters and Unicode

Total characters	294435
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	Ford
2nd row	Infiniti
3rd row	Jeep
4th row	Ford
5th row	Kia

Value	Count	Frequency (%)
ford	8480	17.2%
chevrolet	5391	11.0%
nissan	4749	9.6%
toyota	3627	7.4%
dodge	2750	5.6%
honda	2473	5.0%
hyundai	1926	3.9%
bmw	1868	3.8%
mercedes-benz	1623	3.3%
kia	1578	3.2%
Other values (47)	14763	30.0%

Most occurring characters

Value	Count	Frequency (%)
o	29512	10.0%
e	27145	9.2%
a	20894	7.1%
r	20590	7.0%
d	19455	6.6%
n	16655	5.7%
i	16557	5.6%
s	15864	5.4%
t	11542	3.9%
l	10315	3.5%
Other values (39)	105906	36.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	294435	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	29512	10.0%
e	27145	9.2%
a	20894	7.1%
r	20590	7.0%
d	19455	6.6%
n	16655	5.7%
i	16557	5.6%
s	15864	5.4%
t	11542	3.9%
l	10315	3.5%
Other values (39)	105906	36.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	294435	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	29512	10.0%
e	27145	9.2%
a	20894	7.1%
r	20590	7.0%
d	19455	6.6%
n	16655	5.7%
i	16557	5.6%
s	15864	5.4%
t	11542	3.9%
l	10315	3.5%
Other values (39)	105906	36.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	294435	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	29512	10.0%
e	27145	9.2%
a	20894	7.1%
r	20590	7.0%
d	19455	6.6%
n	16655	5.7%
i	16557	5.6%
s	15864	5.4%
t	11542	3.9%
l	10315	3.5%
Other values (39)	105906	36.0%

model
Text

Missing

Distinct	751
Distinct (%)	1.5%
Missing	963
Missing (%)	1.9%
Memory size	390.8 KiB

Length

Max length	24
Median length	22
Mean length	6.7469258
Min length	1

Characters and Unicode

Total characters	330849
Distinct characters	65
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	104 ?
Unique (%)	0.2%

Sample

1st row	Fusion
2nd row	JX
3rd row	Grand Cherokee
4th row	F-350 Super Duty
5th row	Sportage

Value	Count	Frequency (%)
altima	1691	2.8%
series	1385	2.3%
f-150	1306	2.2%
grand	1302	2.2%
1500	1259	2.1%
fusion	1238	2.1%
camry	1224	2.1%
escape	1135	1.9%
focus	968	1.6%
g	861	1.4%
Other values (626)	47329	79.3%

Most occurring characters

Value	Count	Frequency (%)
a	33422	10.1%
r	24505	7.4%
e	24148	7.3%
o	17441	5.3%
n	16346	4.9%
i	15070	4.6%
s	13676	4.1%
t	12025	3.6%
l	11941	3.6%
C	11140	3.4%
Other values (55)	151135	45.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	330849	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	33422	10.1%
r	24505	7.4%
e	24148	7.3%
o	17441	5.3%
n	16346	4.9%
i	15070	4.6%
s	13676	4.1%
t	12025	3.6%
l	11941	3.6%
C	11140	3.4%
Other values (55)	151135	45.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	330849	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	33422	10.1%
r	24505	7.4%
e	24148	7.3%
o	17441	5.3%
n	16346	4.9%
i	15070	4.6%
s	13676	4.1%
t	12025	3.6%
l	11941	3.6%
C	11140	3.4%
Other values (55)	151135	45.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	330849	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	33422	10.1%
r	24505	7.4%
e	24148	7.3%
o	17441	5.3%
n	16346	4.9%
i	15070	4.6%
s	13676	4.1%
t	12025	3.6%
l	11941	3.6%
C	11140	3.4%
Other values (55)	151135	45.7%

trim
Text

Missing

Distinct	1222
Distinct (%)	2.5%
Missing	988
Missing (%)	2.0%
Memory size	390.8 KiB

Length

Max length	46
Median length	36
Mean length	4.7444095
Min length	1

Characters and Unicode

Total characters	232533
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	336 ?
Unique (%)	0.7%

Sample

1st row	SE
2nd row	JX35
3rd row	Laredo
4th row	XLT
5th row	LX

Value	Count	Frequency (%)
base	4979	8.3%
se	4488	7.5%
s	2648	4.4%
lx	1866	3.1%
lt	1779	3.0%
limited	1771	2.9%
xlt	1734	2.9%
2.5	1625	2.7%
ls	1625	2.7%
sport	1581	2.6%
Other values (707)	36125	60.0%

Most occurring characters

Value	Count	Frequency (%)
L	19240	8.3%
S	18493	8.0%
e	13762	5.9%
i	11933	5.1%
E	11581	5.0%
	11209	4.8%
T	10716	4.6%
a	9740	4.2%
r	8838	3.8%
X	8207	3.5%
Other values (61)	108814	46.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	232533	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	19240	8.3%
S	18493	8.0%
e	13762	5.9%
i	11933	5.1%
E	11581	5.0%
	11209	4.8%
T	10716	4.6%
a	9740	4.2%
r	8838	3.8%
X	8207	3.5%
Other values (61)	108814	46.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	232533	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	19240	8.3%
S	18493	8.0%
e	13762	5.9%
i	11933	5.1%
E	11581	5.0%
	11209	4.8%
T	10716	4.6%
a	9740	4.2%
r	8838	3.8%
X	8207	3.5%
Other values (61)	108814	46.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	232533	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	19240	8.3%
S	18493	8.0%
e	13762	5.9%
i	11933	5.1%
E	11581	5.0%
	11209	4.8%
T	10716	4.6%
a	9740	4.2%
r	8838	3.8%
X	8207	3.5%
Other values (61)	108814	46.8%

body
Text

Missing

Distinct	73
Distinct (%)	0.1%
Missing	1218
Missing (%)	2.4%
Memory size	390.8 KiB

Length

Max length	23
Median length	5
Mean length	5.2589275
Min length	3

Characters and Unicode

Total characters	256541
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	Sedan
2nd row	SUV
3rd row	SUV
4th row	Crew Cab
5th row	SUV

Value	Count	Frequency (%)
sedan	22339	42.3%
suv	12910	24.5%
cab	2901	5.5%
hatchback	2281	4.3%
minivan	2265	4.3%
coupe	1835	3.5%
crew	1455	2.8%
wagon	1395	2.6%
convertible	953	1.8%
g	861	1.6%
Other values (31)	3571	6.8%

Most occurring characters

Value	Count	Frequency (%)
a	35376	13.8%
e	31540	12.3%
S	30414	11.9%
n	30269	11.8%
d	23488	9.2%
V	11241	4.4%
U	10727	4.2%
C	6998	2.7%
b	6756	2.6%
s	6555	2.6%
Other values (38)	63177	24.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	256541	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	35376	13.8%
e	31540	12.3%
S	30414	11.9%
n	30269	11.8%
d	23488	9.2%
V	11241	4.4%
U	10727	4.2%
C	6998	2.7%
b	6756	2.6%
s	6555	2.6%
Other values (38)	63177	24.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	256541	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	35376	13.8%
e	31540	12.3%
S	30414	11.9%
n	30269	11.8%
d	23488	9.2%
V	11241	4.4%
U	10727	4.2%
C	6998	2.7%
b	6756	2.6%
s	6555	2.6%
Other values (38)	63177	24.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	256541	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	35376	13.8%
e	31540	12.3%
S	30414	11.9%
n	30269	11.8%
d	23488	9.2%
V	11241	4.4%
U	10727	4.2%
C	6998	2.7%
b	6756	2.6%
s	6555	2.6%
Other values (38)	63177	24.6%

transmission
Categorical

High correlation Imbalance Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	5986
Missing (%)	12.0%
Memory size	390.8 KiB

automatic	42510
manual	1502
Sedan	2

Length

Max length	9
Median length	9
Mean length	8.8974417
Min length	5

Characters and Unicode

Total characters	391612
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	automatic
2nd row	automatic
3rd row	automatic
4th row	automatic
5th row	automatic

Common Values

Value	Count	Frequency (%)
automatic	42510	85.0%
manual	1502	3.0%
Sedan	2	< 0.1%
(Missing)	5986	12.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automatic	42510	96.6%
manual	1502	3.4%
sedan	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	88026	22.5%
t	85020	21.7%
u	44012	11.2%
m	44012	11.2%
o	42510	10.9%
i	42510	10.9%
c	42510	10.9%
n	1504	0.4%
l	1502	0.4%
S	2	< 0.1%
Other values (2)	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	391612	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	88026	22.5%
t	85020	21.7%
u	44012	11.2%
m	44012	11.2%
o	42510	10.9%
i	42510	10.9%
c	42510	10.9%
n	1504	0.4%
l	1502	0.4%
S	2	< 0.1%
Other values (2)	4	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	391612	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	88026	22.5%
t	85020	21.7%
u	44012	11.2%
m	44012	11.2%
o	42510	10.9%
i	42510	10.9%
c	42510	10.9%
n	1504	0.4%
l	1502	0.4%
S	2	< 0.1%
Other values (2)	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	391612	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	88026	22.5%
t	85020	21.7%
u	44012	11.2%
m	44012	11.2%
o	42510	10.9%
i	42510	10.9%
c	42510	10.9%
n	1504	0.4%
l	1502	0.4%
S	2	< 0.1%
Other values (2)	4	< 0.1%

vin
Text

Distinct	49925
Distinct (%)	99.9%
Missing	1
Missing (%)	< 0.1%
Memory size	390.8 KiB

Length

Max length	17
Median length	17
Mean length	16.99984
Min length	9

Characters and Unicode

Total characters	849975
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	49851 ?
Unique (%)	99.7%

Sample

1st row	3fa6p0h71dr236627
2nd row	5n1al0mn8dc329790
3rd row	1j8gr48k69c529636
4th row	1ftww31rx8ed43632
5th row	kndpbcac3e7642651

Value	Count	Frequency (%)
yv1ls5574w1496928	2	< 0.1%
kl8cd6s94dc512342	2	< 0.1%
19xfb2f85ee234128	2	< 0.1%
yv4982cz1a1553190	2	< 0.1%
1ft8x3bt1bea35997	2	< 0.1%
kndmb233266067038	2	< 0.1%
1gkdt13s562114606	2	< 0.1%
1j4ga59167l119551	2	< 0.1%
jtdkb20u467506884	2	< 0.1%
5tddk3eh3cs112711	2	< 0.1%
Other values (49915)	49979	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	82378	9.7%
2	57285	6.7%
3	54734	6.4%
5	53261	6.3%
4	51475	6.1%
0	44621	5.2%
6	43745	5.1%
7	40753	4.8%
8	40378	4.8%
c	34327	4.0%
Other values (25)	347018	40.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	849975	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	82378	9.7%
2	57285	6.7%
3	54734	6.4%
5	53261	6.3%
4	51475	6.1%
0	44621	5.2%
6	43745	5.1%
7	40753	4.8%
8	40378	4.8%
c	34327	4.0%
Other values (25)	347018	40.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	849975	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	82378	9.7%
2	57285	6.7%
3	54734	6.4%
5	53261	6.3%
4	51475	6.1%
0	44621	5.2%
6	43745	5.1%
7	40753	4.8%
8	40378	4.8%
c	34327	4.0%
Other values (25)	347018	40.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	849975	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	82378	9.7%
2	57285	6.7%
3	54734	6.4%
5	53261	6.3%
4	51475	6.1%
0	44621	5.2%
6	43745	5.1%
7	40753	4.8%
8	40378	4.8%
c	34327	4.0%
Other values (25)	347018	40.8%

state
Categorical

High correlation

Distinct	40
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	390.8 KiB

fl	7379
ca	6581
pa	4879
tx	4055
ga	3214
Other values (35)	23892

Length

Max length	17
Median length	2
Mean length	2.0006
Min length	2

Characters and Unicode

Total characters	100030
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	wi
2nd row	ca
3rd row	ne
4th row	wa
5th row	nv

Common Values

Value	Count	Frequency (%)
fl	7379	14.8%
ca	6581	13.2%
pa	4879	9.8%
tx	4055	8.1%
ga	3214	6.4%
nj	2404	4.8%
il	2124	4.2%
oh	1986	4.0%
nc	1937	3.9%
tn	1867	3.7%
Other values (30)	13574	27.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fl	7379	14.8%
ca	6581	13.2%
pa	4879	9.8%
tx	4055	8.1%
ga	3214	6.4%
nj	2404	4.8%
il	2124	4.2%
oh	1986	4.0%
nc	1937	3.9%
tn	1867	3.7%
Other values (30)	13574	27.1%

Most occurring characters

Value	Count	Frequency (%)
a	17997	18.0%
n	9740	9.7%
c	9716	9.7%
l	9694	9.7%
f	7381	7.4%
t	6082	6.1%
m	5461	5.5%
p	5123	5.1%
i	4871	4.9%
o	4555	4.6%
Other values (25)	19410	19.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100030	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	17997	18.0%
n	9740	9.7%
c	9716	9.7%
l	9694	9.7%
f	7381	7.4%
t	6082	6.1%
m	5461	5.5%
p	5123	5.1%
i	4871	4.9%
o	4555	4.6%
Other values (25)	19410	19.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100030	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	17997	18.0%
n	9740	9.7%
c	9716	9.7%
l	9694	9.7%
f	7381	7.4%
t	6082	6.1%
m	5461	5.5%
p	5123	5.1%
i	4871	4.9%
o	4555	4.6%
Other values (25)	19410	19.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100030	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	17997	18.0%
n	9740	9.7%
c	9716	9.7%
l	9694	9.7%
f	7381	7.4%
t	6082	6.1%
m	5461	5.5%
p	5123	5.1%
i	4871	4.9%
o	4555	4.6%
Other values (25)	19410	19.4%

condition
Real number (ℝ)

Missing

Distinct	41
Distinct (%)	0.1%
Missing	1077
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	30.619422

Minimum	1
Maximum	49
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	390.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	23
median	35
Q3	42
95-th percentile	47
Maximum	49
Range	48
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	13.471054
Coefficient of variation (CV)	0.43995128
Kurtosis	-0.24453918
Mean	30.619422
Median Absolute Deviation (MAD)	8
Skewness	-0.82854595
Sum	1497994
Variance	181.4693
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
19	3723	7.4%
35	2382	4.8%
37	2307	4.6%
44	2256	4.5%
43	2193	4.4%
42	2165	4.3%
36	2049	4.1%
41	2036	4.1%
2	1940	3.9%
39	1816	3.6%
Other values (31)	26056	52.1%

Value	Count	Frequency (%)
1	679	1.4%
2	1940	3.9%
3	969	1.9%
4	1804	3.6%
5	983	2.0%
11	12	< 0.1%
12	11	< 0.1%
13	6	< 0.1%
14	17	< 0.1%
15	15	< 0.1%

Value	Count	Frequency (%)
49	1163	2.3%
48	1143	2.3%
47	1057	2.1%
46	1155	2.3%
45	1120	2.2%
44	2256	4.5%
43	2193	4.4%
42	2165	4.3%
41	2036	4.1%
39	1816	3.6%

odometer
Real number (ℝ)

High correlation

Distinct	41966
Distinct (%)	83.9%
Missing	5
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	68103.882

Minimum	1
Maximum	999999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	390.8 KiB

Quantile statistics

Minimum	1
5-th percentile	10682.7
Q1	28312.5
median	51806
Q3	98735.5
95-th percentile	169696.8
Maximum	999999
Range	999998
Interquartile range (IQR)	70423

Descriptive statistics

Standard deviation	53485.779
Coefficient of variation (CV)	0.78535581
Kurtosis	15.904662
Mean	68103.882
Median Absolute Deviation (MAD)	30041
Skewness	1.9824012
Sum	3.4048536 × 10⁹
Variance	2.8607286 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	0.2%
999999	7	< 0.1%
23870	6	< 0.1%
10936	5	< 0.1%
19940	5	< 0.1%
24088	5	< 0.1%
35546	5	< 0.1%
29184	5	< 0.1%
20161	5	< 0.1%
23720	5	< 0.1%
Other values (41956)	49833	99.7%

Value	Count	Frequency (%)
1	114	0.2%
4	1	< 0.1%
5	2	< 0.1%
6	2	< 0.1%
10	3	< 0.1%
11	3	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
15	1	< 0.1%
21	1	< 0.1%

Value	Count	Frequency (%)
999999	7	< 0.1%
980113	1	< 0.1%
537334	1	< 0.1%
471114	1	< 0.1%
451641	1	< 0.1%
445317	1	< 0.1%
406777	1	< 0.1%
398532	1	< 0.1%
382200	1	< 0.1%
373909	1	< 0.1%

color
Categorical

High correlation

Distinct	21
Distinct (%)	< 0.1%
Missing	54
Missing (%)	0.1%
Memory size	390.8 KiB

black	9882
white	9510
gray	7572
silver	7444
blue	4600
Other values (16)	10938

Length

Max length	9
Median length	8
Mean length	4.6206103
Min length	1

Characters and Unicode

Total characters	230781
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	white
2nd row	gray
3rd row	silver
4th row	white
5th row	white

Common Values

Value	Count	Frequency (%)
black	9882	19.8%
white	9510	19.0%
gray	7572	15.1%
silver	7444	14.9%
blue	4600	9.2%
red	3926	7.9%
—	2213	4.4%
green	1041	2.1%
gold	976	2.0%
beige	782	1.6%
Other values (11)	2000	4.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	9882	19.8%
white	9510	19.0%
gray	7572	15.2%
silver	7444	14.9%
blue	4600	9.2%
red	3926	7.9%
—	2213	4.4%
green	1041	2.1%
gold	976	2.0%
beige	782	1.6%
Other values (11)	2000	4.0%

Most occurring characters

Value	Count	Frequency (%)
e	29764	12.9%
l	23319	10.1%
r	21709	9.4%
i	17915	7.8%
a	17730	7.7%
b	16585	7.2%
g	11305	4.9%
w	10370	4.5%
c	9954	4.3%
k	9885	4.3%
Other values (20)	62245	27.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	230781	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	29764	12.9%
l	23319	10.1%
r	21709	9.4%
i	17915	7.8%
a	17730	7.7%
b	16585	7.2%
g	11305	4.9%
w	10370	4.5%
c	9954	4.3%
k	9885	4.3%
Other values (20)	62245	27.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	230781	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	29764	12.9%
l	23319	10.1%
r	21709	9.4%
i	17915	7.8%
a	17730	7.7%
b	16585	7.2%
g	11305	4.9%
w	10370	4.5%
c	9954	4.3%
k	9885	4.3%
Other values (20)	62245	27.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	230781	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	29764	12.9%
l	23319	10.1%
r	21709	9.4%
i	17915	7.8%
a	17730	7.7%
b	16585	7.2%
g	11305	4.9%
w	10370	4.5%
c	9954	4.3%
k	9885	4.3%
Other values (20)	62245	27.0%

interior
Categorical

Imbalance

Distinct	17
Distinct (%)	< 0.1%
Missing	54
Missing (%)	0.1%
Memory size	390.8 KiB

black	21770
gray	16146
beige	5421
tan	3875
—	1505
Other values (12)	1229

Length

Max length	9
Median length	5
Mean length	4.4007528
Min length	1

Characters and Unicode

Total characters	219800
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	black
2nd row	black
3rd row	gray
4th row	gray
5th row	gray

Common Values

Value	Count	Frequency (%)
black	21770	43.5%
gray	16146	32.3%
beige	5421	10.8%
tan	3875	7.8%
—	1505	3.0%
brown	736	1.5%
red	130	0.3%
silver	100	0.2%
blue	86	0.2%
off-white	38	0.1%
Other values (7)	139	0.3%
(Missing)	54	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	21770	43.6%
gray	16146	32.3%
beige	5421	10.9%
tan	3875	7.8%
—	1505	3.0%
brown	736	1.5%
red	130	0.3%
silver	100	0.2%
blue	86	0.2%
off-white	38	0.1%
Other values (7)	139	0.3%

Most occurring characters

Value	Count	Frequency (%)
a	41804	19.0%
b	28034	12.8%
l	22029	10.0%
c	21770	9.9%
k	21770	9.9%
g	21649	9.8%
r	17193	7.8%
y	16172	7.4%
e	11298	5.1%
i	5580	2.5%
Other values (13)	12501	5.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	219800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	41804	19.0%
b	28034	12.8%
l	22029	10.0%
c	21770	9.9%
k	21770	9.9%
g	21649	9.8%
r	17193	7.8%
y	16172	7.4%
e	11298	5.1%
i	5580	2.5%
Other values (13)	12501	5.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	219800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	41804	19.0%
b	28034	12.8%
l	22029	10.0%
c	21770	9.9%
k	21770	9.9%
g	21649	9.8%
r	17193	7.8%
y	16172	7.4%
e	11298	5.1%
i	5580	2.5%
Other values (13)	12501	5.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	219800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	41804	19.0%
b	28034	12.8%
l	22029	10.0%
c	21770	9.9%
k	21770	9.9%
g	21649	9.8%
r	17193	7.8%
y	16172	7.4%
e	11298	5.1%
i	5580	2.5%
Other values (13)	12501	5.7%

seller
Text

Distinct	5350
Distinct (%)	10.7%
Missing	0
Missing (%)	0.0%
Memory size	390.8 KiB

Length

Max length	50
Median length	41
Mean length	23.02654
Min length	3

Characters and Unicode

Total characters	1151327
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2495 ?
Unique (%)	5.0%

Sample

1st row	lease plan usa
2nd row	infiniti of montclair
3rd row	dm northwest inc
4th row	lexus of tacoma at fife
5th row	kia motors america inc

Value	Count	Frequency (%)
inc	7817	4.6%
services	4332	2.6%
credit	4293	2.5%
motor	4258	2.5%
auto	4240	2.5%
corporation	4209	2.5%
llc	4164	2.5%
financial	4039	2.4%
ford	3336	2.0%
remarketing	3177	1.9%
Other values (4101)	124782	74.0%

Most occurring characters

Value	Count	Frequency (%)
	120287	10.4%
e	102583	8.9%
a	93940	8.2%
r	86156	7.5%
n	85508	7.4%
i	81984	7.1%
o	77318	6.7%
t	71096	6.2%
c	66088	5.7%
s	60198	5.2%
Other values (36)	306169	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1151327	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	120287	10.4%
e	102583	8.9%
a	93940	8.2%
r	86156	7.5%
n	85508	7.4%
i	81984	7.1%
o	77318	6.7%
t	71096	6.2%
c	66088	5.7%
s	60198	5.2%
Other values (36)	306169	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1151327	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	120287	10.4%
e	102583	8.9%
a	93940	8.2%
r	86156	7.5%
n	85508	7.4%
i	81984	7.1%
o	77318	6.7%
t	71096	6.2%
c	66088	5.7%
s	60198	5.2%
Other values (36)	306169	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1151327	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	120287	10.4%
e	102583	8.9%
a	93940	8.2%
r	86156	7.5%
n	85508	7.4%
i	81984	7.1%
o	77318	6.7%
t	71096	6.2%
c	66088	5.7%
s	60198	5.2%
Other values (36)	306169	26.6%

sellingprice
Real number (ℝ)

High correlation

Distinct	971
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13667.282

Minimum	1
Maximum	159000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	390.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1500
Q1	6900
median	12200
Q3	18300
95-th percentile	30700
Maximum	159000
Range	158999
Interquartile range (IQR)	11400

Descriptive statistics

Standard deviation	9841.3572
Coefficient of variation (CV)	0.72006691
Kurtosis	11.629154
Mean	13667.282
Median Absolute Deviation (MAD)	5700
Skewness	2.0358219
Sum	6.8336408 × 10⁸
Variance	96852312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12000	413	0.8%
11000	399	0.8%
14000	396	0.8%
10000	384	0.8%
13000	373	0.7%
11500	362	0.7%
10500	331	0.7%
12500	328	0.7%
9000	320	0.6%
11800	307	0.6%
Other values (961)	46387	92.8%

Value	Count	Frequency (%)
1	1	< 0.1%
150	3	< 0.1%
175	1	< 0.1%
200	21	< 0.1%
225	10	< 0.1%
250	27	0.1%
275	13	< 0.1%
300	113	0.2%
325	17	< 0.1%
350	61	0.1%

Value	Count	Frequency (%)
159000	1	< 0.1%
158000	1	< 0.1%
147000	1	< 0.1%
141000	1	< 0.1%
139000	1	< 0.1%
134500	1	< 0.1%
131000	1	< 0.1%
123000	1	< 0.1%
120000	1	< 0.1%
117500	1	< 0.1%

saledate
Text

Distinct	2321
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Memory size	390.8 KiB

Length

Max length	39
Median length	39
Mean length	38.99864
Min length	5

Characters and Unicode

Total characters	1949932
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	594 ?
Unique (%)	1.2%

Sample

1st row	Wed Feb 04 2015 02:30:00 GMT-0800 (PST)
2nd row	Tue Jun 16 2015 05:00:00 GMT-0700 (PDT)
3rd row	Thu Jan 15 2015 03:00:00 GMT-0800 (PST)
4th row	Wed Feb 11 2015 05:20:00 GMT-0800 (PST)
5th row	Fri Mar 06 2015 04:00:00 GMT-0800 (PST)

Value	Count	Frequency (%)
2015	45155	12.9%
pst	35500	10.1%
gmt-0800	35500	10.1%
wed	14722	4.2%
tue	14662	4.2%
feb	14602	4.2%
pdt	14498	4.1%
gmt-0700	14498	4.1%
thu	13868	4.0%
jan	12657	3.6%
Other values (261)	134326	38.4%

Most occurring characters

Value	Count	Frequency (%)
0	431242	22.1%
	299988	15.4%
T	128526	6.6%
:	99996	5.1%
1	94946	4.9%
2	86056	4.4%
M	60213	3.1%
5	59080	3.0%
)	49998	2.6%
G	49998	2.6%
Other values (30)	589889	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1949932	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	431242	22.1%
	299988	15.4%
T	128526	6.6%
:	99996	5.1%
1	94946	4.9%
2	86056	4.4%
M	60213	3.1%
5	59080	3.0%
)	49998	2.6%
G	49998	2.6%
Other values (30)	589889	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1949932	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	431242	22.1%
	299988	15.4%
T	128526	6.6%
:	99996	5.1%
1	94946	4.9%
2	86056	4.4%
M	60213	3.1%
5	59080	3.0%
)	49998	2.6%
G	49998	2.6%
Other values (30)	589889	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1949932	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	431242	22.1%
	299988	15.4%
T	128526	6.6%
:	99996	5.1%
1	94946	4.9%
2	86056	4.4%
M	60213	3.1%
5	59080	3.0%
)	49998	2.6%
G	49998	2.6%
Other values (30)	589889	30.3%

	color	condition	interior	odometer	sellingprice	state	transmission	year
color	1.000	0.056	0.127	0.075	0.061	0.322	0.710	0.096
condition	0.056	1.000	0.059	-0.405	0.483	0.089	0.034	0.387
interior	0.127	0.059	1.000	0.099	0.073	0.099	0.230	0.109
odometer	0.075	-0.405	0.099	1.000	-0.705	0.099	0.020	-0.818
sellingprice	0.061	0.483	0.073	-0.705	1.000	0.068	0.017	0.678
state	0.322	0.089	0.099	0.099	0.068	1.000	0.709	0.094
transmission	0.710	0.034	0.230	0.020	0.017	0.709	1.000	0.070
year	0.096	0.387	0.109	-0.818	0.678	0.094	0.070	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	year	make	model	trim	body	transmission	vin	state	condition	odometer	color	interior	seller	sellingprice	saledate
0	2013	Ford	Fusion	SE	Sedan	automatic	3fa6p0h71dr236627	wi	47.0	17548.0	white	black	lease plan usa	14200	Wed Feb 04 2015 02:30:00 GMT-0800 (PST)
1	2013	Infiniti	JX	JX35	SUV	automatic	5n1al0mn8dc329790	ca	43.0	22035.0	gray	black	infiniti of montclair	31000	Tue Jun 16 2015 05:00:00 GMT-0700 (PDT)
2	2009	Jeep	Grand Cherokee	Laredo	SUV	automatic	1j8gr48k69c529636	ne	34.0	95559.0	silver	gray	dm northwest inc	11600	Thu Jan 15 2015 03:00:00 GMT-0800 (PST)
3	2008	Ford	F-350 Super Duty	XLT	Crew Cab	automatic	1ftww31rx8ed43632	wa	43.0	135870.0	white	gray	lexus of tacoma at fife	15400	Wed Feb 11 2015 05:20:00 GMT-0800 (PST)
4	2014	Kia	Sportage	LX	SUV	automatic	kndpbcac3e7642651	nv	44.0	13604.0	white	gray	kia motors america inc	18500	Fri Mar 06 2015 04:00:00 GMT-0800 (PST)
5	2012	Toyota	Tacoma	V6	Double Cab	automatic	5tflu4en0cx040958	tx	35.0	33131.0	silver	gray	cantu chevrolet	26700	Wed Feb 04 2015 02:00:00 GMT-0800 (PST)
6	2006	Jeep	Grand Cherokee	Laredo	suv	automatic	1j4gr48k66c280848	nj	29.0	100783.0	red	gray	ramsey volvo	6400	Tue Jun 16 2015 03:00:00 GMT-0700 (PDT)
7	2012	Nissan	Altima	2.5 S	Sedan	automatic	1n4al2ap8cc124254	nj	37.0	28514.0	white	black	nissan-infiniti lt	14400	Wed Dec 31 2014 09:30:00 GMT-0800 (PST)
8	2013	Nissan	Maxima	3.5 S	Sedan	automatic	1n4aa5ap7dc800119	nc	41.0	50662.0	silver	black	regional acceptance corporation / greenville	13900	Mon Jan 12 2015 09:30:00 GMT-0800 (PST)
9	2003	Nissan	Pathfinder	LE	SUV	NaN	jn8dr09x03w714062	fl	19.0	170588.0	beige	beige	coral springs honda	2300	Fri Jan 09 2015 09:30:00 GMT-0800 (PST)

	year	make	model	trim	body	transmission	vin	state	condition	odometer	color	interior	seller	sellingprice	saledate
49990	2004	Acura	TL	3.2	Sedan	automatic	19uua662x4a008912	ca	24.0	113649.0	gray	black	south coast acura	7400	Wed Feb 11 2015 04:30:00 GMT-0800 (PST)
49991	2012	Chevrolet	Camaro	SS	Coupe	manual	2g1fs1ew3c9100412	ga	41.0	17831.0	silver	black	tdaf remarketing	21500	Thu Feb 05 2015 02:00:00 GMT-0800 (PST)
49992	2012	Lincoln	MKZ	Base	Sedan	automatic	3lnhl2gc3cr815962	pa	32.0	26459.0	gray	beige	ford motor credit company llc	14300	Wed Jan 14 2015 01:00:00 GMT-0800 (PST)
49993	1997	Cadillac	Catera	Base	Sedan	automatic	w06vr54r3vr162162	fl	2.0	93631.0	gold	beige	courtesy kia of brandon	300	Thu Jan 15 2015 08:20:00 GMT-0800 (PST)
49994	2014	Chrysler	Town and Country	Touring	Minivan	automatic	2c4rc1bg9er158574	ga	48.0	48836.0	black	beige	enterprise veh exchange/rental	16900	Tue Feb 03 2015 01:30:00 GMT-0800 (PST)
49995	2013	Ford	F-150	XLT	SuperCrew	automatic	1ftew1cm2dkf73954	md	46.0	31313.0	red	gray	ars/enterprise	22600	Tue Feb 03 2015 01:30:00 GMT-0800 (PST)
49996	2012	Nissan	Sentra	2	Sedan	automatic	3n1ab6ap6cl754270	ca	39.0	23385.0	gray	gray	metro nissan of montclair	9700	Thu Jan 22 2015 04:00:00 GMT-0800 (PST)
49997	2012	Toyota	Highlander	Base	SUV	automatic	5tdzk3eh5cs064330	nc	39.0	75549.0	black	tan	fleet lease remarketing	18400	Mon Jan 26 2015 01:30:00 GMT-0800 (PST)
49998	2007	Chrysler	Aspen	Limited	SUV	automatic	1a8hx58n57f585637	ca	19.0	78352.0	black	gray	a l financial	9100	Wed Jan 21 2015 04:30:00 GMT-0800 (PST)
49999	2007	Chevrolet	Impala	LS	sedan	automatic	2g1wb58k579369419	fl	38.0	109181.0	beige	beige	dt credit corporation	5400	Wed May 27 2015 08:25:00 GMT-0700 (PDT)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters